package com.laxcen.smoke.dao;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

@Mapper
@Repository
public interface RemoteDao {

    @Select("select distinct sbox.no boxno from real_board_box rbb left join smartbox sbox on rbb.BoxId = sbox.id where rbb.no = #{boxno}")
    String getBoxno(String boxno);

    @Select("select distinct sm.no smartno from real_smart_smartboard rss left join smart sm on rss.smartid = sm.id where sm.no = #{smartno} ")
    String getSmartsno(String smartno);

}
